There are two ways to enter & verify data on this demo worksheet:
1. Ctrl-F (or Globe-Form Enter) to enter data using
Globe's automatic, verified data entry routine.
-- or --
2. Use the [Tab] key to move from field to field. Press
Ctrl-V (or Globe-Form Verify) when done entering data.
*10 [Reference
Reference Number:
Enter the 6 digit number from the upper right corner of the form.
If the number is not present on the form, enter the Purchase Order number.
Alpha Suffix: Place the following suffix on the reference number as applicable:
R = rush
C = credit hold
B = backorder
I = interoffice
Forms can not be processed without a valid reference number.
*20 [Product
Press Ctrl-L for a list of valid products.
Double click on the appropriate product description.
*30 [Help System
Globe/XL brings a new meaning to the term "context-sensitive help". Help can be linked to individual cells providing a visual and logical help system.
Globe/XL's Designer module allows help to be defined, with no programming involved whatsoever. The user simply selects the cell, and chooses: Design-Help. Aside from entering the help text, Globe/XL takes care of the rest.
*40 [List Boxes
The Globe/XL list box feature provides far more then user convienence. It offers powerful table lookup data validation which can eliminate costly and time consuming spreadsheet errors.
Globe/XL's Designer module allows a user to link list boxes to individual cells, without programming.
To use the Globe/XL List Box:
Select an appropriate cell (one linked to a list box).
Press Ctrl-L (or Globe-List command).
Double click the correct item from the list.
The chosen item is entered into the cell automatically.
Table-lookup validation can be performed on the fly, or an entire worksheet (or section thereof) can be verified before saving.
*50 [Validation
Globe/XL offers thorough data validation features to ensure spreadsheet integrity. In addition to the table-lookup provided by the list box feature, the following criteria can be specified:
Types of data: Text, Number, Date, Time, Virtual
Minimum length or value
Maximum length or value
Is zero or null allowed?
Security level
Table lookup
Default cell value
Custom verification routine (optional)
The security level setting (per cell) can be one of the following:
* No security.
* Warn user of errors, but allow them.
* Make every effort to disallow errors.
(optimum security requires a "closed" system whereby all spreadsheet
access is controlled by macro.)
*70 [Integration
While Globe/XL is designed for the mainstream spreadsheet user, it has features that make it easy to integrate into custom applications.
The program can be started up with no menu system, if desired. It also includes the following commands to accomodate the Excel developer:
HIDE_YOURSELF Removes the Globe menu, but Globe remains in memory.
GOTO_SLEEP Globe goes completely dormant, including Ctrl keys.
CLOSE_GLOBE Globe shuts down completely.
Globe works hand in hand with another LEX Software product, AppGen/XL. When used in tandem, they form a complete structured development environment.
*110 [General Info
Globel/XL is a global extension to Microsoft Excel providing the following features:
* Visual & logical context-sensitive custom help system.
* Structured, comprehensive data validation system.
* Context-sensitive pop-up list boxes.
* Automatic verified data entry using dialog routines.
* No macro programming required!
The unifying theme behind this feature list is the accuracy of your spreadsheet data. While many spreadsheet tools help find errors, Globe/XL prevents the errors from occuring in the first place.
Experienced macro language programmers have expoited Excel's advanced customization abilities to enhance the ease-of-use, power, and integrity of spreadsheet applications. Globe/XL places these tools into the hands of the everyday spreadsheet user.
Globe/XL works hand in hand with other LEX Software Systems products:
